Introduction

Our problem domain revolves around the topic of COVID-19 and vaccination statistics. We are interested in this field/domain because there are many aspects of COVID-19 that are important to track. Data on vaccinations can help track the current situation of COVID-19, and as more and more people get vaccinated, data on this topic can allow us to know of a rough estimate as to how things will be like in the future. The disease has taken over the world, and in the United States we have seen the harsh impacts of the disease. Displaying vaccination statistics is a sign of hope that our lives will soon go back to normal. I downloaded the data from this link, on Kaggle. This data set is collected by Our World in Data, and they collected data about the current U.S residents and the vaccines distributed. As of May 9th, there are 6784 observations and 14 features.

Since our data set revolves around the COVID-19 vaccine statistics from each state in the U.S, the summary information that we calculated shows the average population of each state in the U.S, which is 6181134. The average total people vaccinated in each state is 2765534. Using those two pieces of information, we were able to get the average percentage of vaccinated people per state compared to the number of residents, which turned out to be 44.7%. For further analysis, the mean for total vaccines in each state was 3957863, making the average percentage of people vaccinated compared to the number of vaccines available per state 69.9%.

Table intro

This table contains aggregated Covid-19 vaccination information of 51 states in the US by May 9th, 2021. This table is grouped by states. The final number of vaccination by May 9th, 2021 and the mean daily vaccination are calculated, so that it is easy to compare the progress of Covid-19 vaccination between states.

The table is sorted descending by the amount of total vaccination.

State total_vaccinations total_distributed total_people_vaccinated mean_daily_vaccination population
California 33109680 42020680 20284982 276777 39613500
Texas 20215285 27376775 11508786 166111 29730300
Florida 16431037 22007995 9460421 134741 21944600
Pennsylvania 10952811 13571705 6727935 91363 12804100
Illinois 10146731 12855545 6184414 84242 12569300
Ohio 8930170 11024855 4890014 74817 11714600
New Jersey 7934175 9490755 4813916 66219 8874520
Michigan 7688179 10065270 4438313 64073 9992430
North Carolina 7498381 10441180 4248350 63067 10701000
Virginia 7233201 8689335 4234063 61021 8603980
Massachusetts 6858691 8068900 4141658 56624 6912240
Georgia 6799470 9921025 3869064 57008 10830000
Washington 6367124 7942520 3772502 52906 7796940
Arizona 5372605 7081205 3077983 45203 7520100
Maryland 5221259 6647830 3094920 43569 6065440
Wisconsin 4961248 5555605 2746530 41577 5852490
Colorado 4880920 5861710 2804920 39686 5893630
Minnesota 4721950 5348340 2788250 39126 5706400
Indiana 4506166 5727410 2553033 36722 6805660
Tennessee 4346845 5671770 2444465 35037 6944260
Missouri 4243742 5508655 2388865 35218 6169040
Connecticut 3512139 4077035 2043434 28764 3552820
South Carolina 3439210 4728205 1947391 29044 5277830
Oregon 3395077 4219185 2030348 27798 4289440
Kentucky 3309482 4092275 1893307 27486 4480710
Louisiana 2861659 3754030 1553840 23265 4627000
Oklahoma 2786611 3834415 1560916 22924 3990440
Alabama 2768204 4277330 1654267 23091 4934190
Iowa 2564630 2973685 1440023 21283 3167970
Utah 2263595 2733780 1311972 18943 3310770
Nevada 2209675 2636770 1271782 18431 3185790
Puerto Rico 2174111 3477130 1356681 17514 3194370
Kansas 2146247 2826985 1275039 17847 2917220
New Mexico 1927317 2112295 1110016 15891 2105000
Arkansas 1900002 2677170 1107515 16272 3033950
Mississippi 1655785 2496365 951726 13852 2966410
Nebraska 1536579 1851220 868691 12534 1952000
Hawaii 1386097 1565860 832725 11379 1406430
Maine 1276858 1520230 768255 10562 1354520
West Virginia 1216002 1682345 657366 9654 1767860
New Hampshire 1159614 1422785 831667 9759 1372200
Idaho 1132383 1490225 626090 9539 1860120
Rhode Island 988104 1289815 582139 8185 1061510
Delaware 825352 1057915 478333 6870 990334
Montana 799489 1024695 449535 6561 1085000
South Dakota 731988 910375 403387 5953 896581
District of Columbia 655560 918975 360914 5352 714153
Vermont 632395 757120 382267 5174 623251
North Dakota 581749 654800 305561 4710 770026
Alaska 571368 777945 312535 4649 724357
Wyoming 369975 490875 201135 3063 581075

Summary Charts

Chart 1

  • Chart 1 displays the total number of people that got vaccinated per state up until May 9th, 2021.
  • Bar chart was used to help visualize the comparison of amount of vaccinated people among different states and identify states with the most vaccinated population and states with the lowest vaccinated population.

Chart 2

  • Chart 2 compares the population of each state with its vaccinated population up until May 9th, 2021.
  • The grouped bar graph indicates the estimated amount of people who have not got their vaccination in each state and visually demonstrates the gap between total population and total vaccinated population on a state-wide level.

Chart 3

  • Chart 3 compares each state’s total population with its calculated average daily vaccination given to the public up until May 9th, 2021.
  • The scatter plot graph helps establish a visible trend where readers can examine the relationship between each state’s total population and calculated average daily vaccination given to the public.